How to: Add a Combo Box that uses pre-existing values to a form using a Wizard.
Solution:
Click the 'Forms' tab in the Database window, and select the desired form. Click 'Design'. Click 'Combo Box' in the Toolbox, and click on the form.
NOTE 1: The 'Developer Tools' must be installed.
NOTE 2: If the Database window is not active, activate the Database window.
1) Click the 'Forms' tab in the Database window.
Forms tab
2) Select the desired form from the list box. (The selected form is highlighted.)
3) Click 'Design'. (The selected form appears in the Design view, and the Toolbox appears.)
4) Make sure the 'Control Wizard' button appears depressed.
Control Wizard depressed.
5) Click 'Combo Box' in the Toolbox.
6) Place the mouse pointer at the desired location in the form. (The cursor changes to the Combo Box icon.)
7) Click on the form. (The Combo Box Wizard dialog box appears.)
8) Select the 'I want the combo box to look up the values in a table or query' radio button.
9) Click 'Next'.
10) Select the desired table or query to provide the values.
NOTE: To display tables only in the list box, select the 'Tables' radio button in the 'View' group. To display queries only in the list box, select the 'Queries' radio button. To display both tables and queries in the list box, select the 'Both' radio button.
11) Click 'Next'.
12) Select the fields that contain the values to be included in the combo box:
a) Select the desired field from the 'Available Fields' list box.
b) Click the '>' button. (The selected field appears in the Selected Fields list box.)
c) Repeat steps 12)a) and 12)b) for each field to include in the combo box.
13) Click 'Next'.
14) Adjust the column widths as desired.
15) Click 'Next'.
16) (Special Case) If more than one field was selected in step 12), do the following:
a) From the 'Available Fields' list box, select a field to identify a row when it is selected in the combo box.
b) Click 'Next'.
17) Do one of the following:
a) To use the selected value from the combo box later, select the 'Remember the value for later use' radio button.
b) To store the selected value from the combo box in the database:
1] Select the 'Store that value in this field' radio button.
2] Type the field in which to store the selected value.
18) Click 'Next'.
19) Type a label name for the combo box in the 'What label would you like for your combo box?' box.
20) Click 'Finish'.
